package com.syy.spider.dao;

import com.syy.spider.pojo.Picture;
import com.syy.spider.pojo.User_title;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

@Mapper
@Repository
public interface SpiderMapper {
    int insertPicInfo(@Param("pictures") Picture pictures);

    List<Picture> getImgs(@Param("username") String username,@Param("title") String title);

    User_title selectUserTitle(@Param("username") String username, @Param("spiderName") String spiderName);

    void insertTitle(@Param("username") String user, @Param("spiderName") String spiderName);

    List<User_title> getUserTitle(@Param("username") String username);

    String getTitle(@Param("id") Integer id);

    Picture selectPictureById(@Param("id") int picId);

    int deleteFav(@Param("id") int id);

    List<Picture> selectPicturesByTitle(@Param("username") String username,@Param("title") String title);

    void deleteTitle(@Param("username") String username, @Param("title") String title);

    List<User_title> getUserTitleshengxu(@Param("username") String username);

    List<User_title> getUserTitlejiangxu(@Param("username") String username);
}
